Back
undefined
IN
Skip navigation
7
undefined
IN

Home
Explore
Subscriptions
Library
History
Your videos
Watch later
Liked videos
Loop

Subscriptions

CreepsMcPasta
MrCreepyPasta
Valorant Curios
Lethamyr
freeCodeCamp.org
theScore esports
Vexsper
Show 152 more
Show less

More from YouTube

YouTube Premium
Movies
Gaming
Live
Fashion & Beauty
Learning
Sports

Settings
Report history
Help
Send feedback
AboutPressCopyrightContact usCreatorsAdvertiseDevelopers
TermsPrivacyPolicy & SafetyHow YouTube worksTest new features
© 2021 Google LLC

Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby)
If playback doesn't begin shortly, try restarting your device.
5 seconds
Aggregate Statistics using Groupby (Sum, Mean, Counting)
52:33
You're signed out
Videos you watch may be added to the TV's watch history and influence TV recommendations. To avoid this, cancel and sign in to YouTube on your computer.
Up next
Live
Upcoming
Play Now
Solving real world data science tasks with Python Pandas!
1:26:07
Keith Galli
SUBSCRIBE
SUBSCRIBED
Recent MIT Graduate. I make educational videos on Computer Science, Programming, Board Games, and more! I found online videos to be extremely helpful as I progressed through the educational system growing up so I decided to make a channel of my own. Let me know what I should make next! -Keith :)
Intro to Data Visualization in Python with Matplotlib! (line graph, bar chart, title, labels, size)
32:33
Switch camera
Share
An error occurred while retrieving sharing information. Please try again later.
0:00
1:00:26
22:01 / 1:00:26

Transcript

Chapters

Why Pandas?

0:00

Installing Pandas

1:46

Getting the data used in this video

2:03

Loading the data into Pandas (CSVs, Excel, TXTs, etc.)

3:50

Reading Data (Getting Rows, Columns, Cells, Headers, etc.)

8:49

Iterate through each Row

13:10

Getting rows based on a specific condition

14:11

High Level description of your data (min, max, mean, std dev, etc.)

15:47

Sorting Values (Alphabetically, Numerically)

16:24

Making Changes to the DataFrame

18:19

Adding a column

18:56

Deleting a column

21:22

Summing Multiple Columns to Create new Column.

22:14

Rearranging columns

24:14

Saving our Data (CSV, Excel, TXT, etc.)

28:06

Filtering Data (based on multiple conditions)

31:47

Reset Index

35:40

Regex Filtering (filter based on textual patterns)

37:41

Conditional Changes

43:08

Aggregate Statistics using Groupby (Sum, Mean, Counting)

47:57

Working with large amounts of data (setting chunksize)

54:53
Sync to video time

NaN / undefined

Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby)

1,385,221 views • Oct 26, 2018 • Code faster & smarter with Kite's free AI-powered coding assistant! (download link) https://www.kite.com/get-kite/?utm_me... Practice your Python Pandas data science skills with problems on StrataScratch! https://stratascratch.com/?via=keith Data & code used in this Tutorial: https://github.com/KeithGalli/pandas Python Pandas Documentation: http://pandas.pydata.org/pandas-docs/... Let me know if you have any questions! In this video we walk through many of the fundamental concepts to use the Python Pandas Data Science Library. We start off by installing pandas and loading in an example csv. We then look at different ways to read the data. Read a column, rows, specific cell, etc. Also ways to read data based on conditioning. We then move into some more advanced ways to sort & filter data. We look at making conditional changes to our data. We also start doing aggregate stats using the groupby function. We finished the video talking about how you would work with a very large dataset (many gigabytes) I realized as I upload this video there are some additional things I want to talk about in a later video. The first thing that comes to mind immediately is using the apply() function on a dataframe to alter the data using a custom or lambda function. If you have questions on this or anything else before I get around to making a part 2, feel free to write me a note in the comments. If you enjoyed this video, be sure to throw it a like and make sure to subscribe to not miss any future videos! Thanks for watching friends! Happy coding! :) --------------------------------------------- Follow me on social media! Instagram | https://www.instagram.com/keithgalli/ Twitter | https://twitter.com/keithgalli --------------------------------------------- Link to original source of data from Kaggle: https://www.kaggle.com/abcsds/pokemon --------------------------------------------- Video Outline! 0:00 - Why Pandas? 1:46 - Installing Pandas 2:03 - Getting the data used in this video 3:50 - Loading the data into Pandas (CSVs, Excel, TXTs, etc.) 8:49 - Reading Data (Getting Rows, Columns, Cells, Headers, etc.) 13:10 - Iterate through each Row 14:11 - Getting rows based on a specific condition 15:47 - High Level description of your data (min, max, mean, std dev, etc.) 16:24 - Sorting Values (Alphabetically, Numerically) 18:19 - Making Changes to the DataFrame 18:56 - Adding a column 21:22 - Deleting a column 22:14 - Summing Multiple Columns to Create new Column. 24:14 - Rearranging columns 28:06 - Saving our Data (CSV, Excel, TXT, etc.) 31:47 - Filtering Data (based on multiple conditions) 35:40 - Reset Index 37:41 - Regex Filtering (filter based on textual patterns) 43:08 - Conditional Changes 47:57 - Aggregate Statistics using Groupby (Sum, Mean, Counting) 54:53 - Working with large amounts of data (setting chunksize) ------------------------- If you are curious to learn how I make my tutorials, check out this video: https://youtu.be/LEO4igyXbLs *I use affiliate links on the products that I recommend. I may earn a purchase commission or a referral bonus from the usage of these links.
Show less
Show more
34K
274
Share
Save
Keith Galli
Keith Galli
Verified
123K subscribers
Subscribe

Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby)

1,385,221 views1.3M views
Oct 26, 2018
34K
274
Share
Save
34,097 / 274
Keith Galli
Keith Galli
Verified
123K subscribers
Subscribe
Code faster & smarter with Kite's free AI-powered coding assistant! (download link) https://www.kite.com/get-kite/?utm_me... Practice your Python Pandas data science skills with problems on StrataScratch! https://stratascratch.com/?via=keith Data & code used in this Tutorial: https://github.com/KeithGalli/pandas Python Pandas Documentation: http://pandas.pydata.org/pandas-docs/... Let me know if you have any questions! In this video we walk through many of the fundamental concepts to use the Python Pandas Data Science Library. We start off by installing pandas and loading in an example csv. We then look at different ways to read the data. Read a column, rows, specific cell, etc. Also ways to read data based on conditioning. We then move into some more advanced ways to sort & filter data. We look at making conditional changes to our data. We also start doing aggregate stats using the groupby function. We finished the video talking about how you would work with a very large dataset (many gigabytes) I realized as I upload this video there are some additional things I want to talk about in a later video. The first thing that comes to mind immediately is using the apply() function on a dataframe to alter the data using a custom or lambda function. If you have questions on this or anything else before I get around to making a part 2, feel free to write me a note in the comments. If you enjoyed this video, be sure to throw it a like and make sure to subscribe to not miss any future videos! Thanks for watching friends! Happy coding! :) --------------------------------------------- Follow me on social media! Instagram | https://www.instagram.com/keithgalli/ Twitter | https://twitter.com/keithgalli --------------------------------------------- Link to original source of data from Kaggle: https://www.kaggle.com/abcsds/pokemon --------------------------------------------- Video Outline! 0:00 - Why Pandas? 1:46 - Installing Pandas 2:03 - Getting the data used in this video 3:50 - Loading the data into Pandas (CSVs, Excel, TXTs, etc.) 8:49 - Reading Data (Getting Rows, Columns, Cells, Headers, etc.) 13:10 - Iterate through each Row 14:11 - Getting rows based on a specific condition 15:47 - High Level description of your data (min, max, mean, std dev, etc.) 16:24 - Sorting Values (Alphabetically, Numerically) 18:19 - Making Changes to the DataFrame 18:56 - Adding a column 21:22 - Deleting a column 22:14 - Summing Multiple Columns to Create new Column. 24:14 - Rearranging columns 28:06 - Saving our Data (CSV, Excel, TXT, etc.) 31:47 - Filtering Data (based on multiple conditions) 35:40 - Reset Index 37:41 - Regex Filtering (filter based on textual patterns) 43:08 - Conditional Changes 47:57 - Aggregate Statistics using Groupby (Sum, Mean, Counting) 54:53 - Working with large amounts of data (setting chunksize) ------------------------- If you are curious to learn how I make my tutorials, check out this video: https://youtu.be/LEO4igyXbLs *I use affiliate links on the products that I recommend. I may earn a purchase commission or a referral bonus from the usage of these links.
Show less Show more
Why this ad?
Try for Free
Ad
www.grammarly.com
Download
All Python pandas Array data structure Data Structures Microsoft Excel Related Recently uploaded Watched
58:41 Now playing

Complete Python NumPy Tutorial (Creating Arrays, Indexing, Math, Statistics, Reshaping)

Keith Galli
Keith Galli
Verified
•
496K views 2 years ago
16:22 Now playing

THIS NEW IMPOSSIBLE FREESTYLE COURSE MADE ME RAGE QUIT

Lethamyr
Lethamyr
Verified
•
99K views 1 week ago
9:40 Now playing

This Was the Day the World Almost Ended

RealLifeLore
RealLifeLore
•
3M views 2 years ago
3:12 Now playing

Alan Walker - Sing Me To Sleep

Alan Walker
Alan Walker
Official Artist Channel
•
645M views 5 years ago
Now playing

Mix - Keith Galli

YouTube
YouTube
•
8:41 Now playing

What’s the Farthest Away Thing You Can See?

RealLifeLore
RealLifeLore
•
1.6M views 2 years ago
6:58 Now playing

Fade To Black

Metallica
Metallica
Official Artist Channel
•
42M views 4 years ago
15:13 Now playing

VALORANT : 15 MINUTES OF TRY NOT TO LAUGH MOMENTS

Vexsper
Vexsper
•
1.3M views 6 months ago
3:45:41 Now playing

Python Django Web Framework - Full Course for Beginners

freeCodeCamp.org
freeCodeCamp.org
Verified
•
2.4M views 2 years ago
53:06 Now playing

Python Object Oriented Programming (OOP) - For Beginners

Tech With Tim
Tech With Tim
Verified
•
1M views 1 year ago
58:10 Now playing

Python NumPy Tutorial for Beginners

freeCodeCamp.org
freeCodeCamp.org
Verified
•
422K views 1 year ago
29:15 Now playing

TOP 100 CALCULATED POTATO LEAGUE CLIPS OF ALL TIME

WASDCommunity
WASDCommunity
Verified
•
45K views 23 hours ago
New
3:43 Now playing

Lost Sky - Where We Started (feat. Jex) [Music Video]

Future Music
Future Music
•
8M views 1 year ago
1:39:48 Now playing

Intro to Data Science - Crash Course for Beginners

freeCodeCamp.org
freeCodeCamp.org
Verified
•
183K views 2 years ago
21:47 Now playing

How do I select multiple rows and columns from a pandas DataFrame?

Data School
Data School
•
244K views 5 years ago
32:33 Now playing

Intro to Data Visualization in Python with Matplotlib! (line graph, bar chart, title, labels, size)

Keith Galli
Keith Galli
Verified
•
114K views 2 years ago
23:06 Now playing

Pandas for Data Science in 20 Minutes | Python Crash Course

Nicholas Renotte
Nicholas Renotte
•
7.7K views 11 months ago
8:41 Now playing

He Threw a Game By Accident and Got Fined a Month's Salary

theScore esports
theScore esports
Verified
•
81K views 17 hours ago
New
13:32 Now playing

I said YES to every Instagram DM for 24 hours... (Rocket League)

amustycow
amustycow
Verified
•
624K views 5 days ago
New
1:31:41 Now playing

Matplotlib Crash Course

freeCodeCamp.org
freeCodeCamp.org
Verified
•
62K views 1 year ago
Show more

NaN / undefined
,